#+NAME: time-tracking-2020-05-12
#+CONSTANTS: workinghours=8 starttime=08:55 overtimehours=25.46 dstraininghours=59.16
|   | activity       | last update | est. | time spent | meeting | daily tasks | tracked |
|---+----------------+-------------+------+------------+---------+-------------+---------|
|   | activity 1     |       10:00 |   20 |         20 |       0 |           1 |       0 |
|   | activity 2     |             |   30 |         30 |       0 |           1 |       0 |
|   | activity 3     |             |    5 |          8 |       1 |           1 |       0 |
|   | activity 4     |             |   10 |         10 |       0 |           1 |       0 |
|---+----------------+-------------+------+------------+---------+-------------+---------|
| # | total:         |             |   65 |         68 |       1 |           4 |         |
| # | in minutes:    |             |   65 |         68 |       8 |          68 |         |
| # | in hours:      |             | 1.08 |       1.13 |     0.1 |         1.1 |         |
| # | time left:     |             | 6.92 |       6.87 |         |             |         |
| # | overtime left: |             |      |      18.59 |         |             |         |
#+TBLFM: @6$4=vsum(@I$4..@II$4);EN::@6$5=vsum(@I$5..@II$5);EN::@6$6=vsum(@I$6..@II$6);EN::@6$7=vsum(@I$7..@II$7);EN::@7$4=@6$4::@7$5=vsum(@I$5..@II$5);EN::@7$6=inner(mul,add,@I$5..@II$5,@I$6..@II$6);EN::@7$7=inner(mul,add,@I$5..@II$5,@I$7..@II$7);EN::@8$4=vsum(@I$4..@II$4)/60;%.2f;EN::@8$5=vsum(@I$5..@II$5)/60;%.2f;EN::@8$6=vsum(@I$5..@II$5*@I$6..@II$6)/60;%.1f;EN::@8$7=inner(mul,add,@I$5..@II$5,@I$7..@II$7)/60;%.1f;EN::@9$4=$workinghours-vsum(@I$4..@II$4)/60;%.2f;EN::@9$5=$workinghours-vsum(@I$5..@II$5)/60;%.2f;EN::@10$5=(($overtimehours*60)+(@7$5-($workinghours*60))) / 60;%.2f;EN
